150 research outputs found

    Clustering-Based Materialized View Selection in Data Warehouses

    Full text link
    Materialized view selection is a non-trivial task. Hence, its complexity must be reduced. A judicious choice of views must be cost-driven and influenced by the workload experienced by the system. In this paper, we propose a framework for materialized view selection that exploits a data mining technique (clustering), in order to determine clusters of similar queries. We also propose a view merging algorithm that builds a set of candidate views, as well as a greedy process for selecting a set of views to materialize. This selection is based on cost models that evaluate the cost of accessing data using views and the cost of storing these views. To validate our strategy, we executed a workload of decision-support queries on a test data warehouse, with and without using our strategy. Our experimental results demonstrate its efficiency, even when storage space is limited

    Quantifying the frequency and volume of urine deposition by grazing sheep using tri-axial accelerometers

    Get PDF
    Urine patches deposited in pasture by grazing animals are sites of reactive nitrogen (N) loss to the environment due to high concentrations of N exceeding pasture uptake requirements. In order to upscale N losses from the urine patch, several urination parameters are required, including where, when and how often urination events occur as well as the volume and chemical composition. There are limited data available in this respect, especially for sheep. Here, we seek to address this knowledge gap by using non-invasive sensor-based technology (accelerometers) on ewes grazing in situ, using a Boolean algorithm to detect urination events in the accelerometer signal. We conducted an initial study with penned Welsh Mountain ewes (n = 5), with accelerometers attached to the hind, to derive urine flow rate and to determine whether urine volume could be estimated from ewe squat time. Then accelerometers attached to the hind of Welsh Mountain ewes (n = 30 at each site) were used to investigate the frequency of sheep urination events (n = 35 946) whilst grazing two extensively managed upland pastures (semi-improved and unimproved) across two seasons (spring and autumn) at each site (35–40 days each). Sheep urinated at a frequency of 10.2 ± 0.2 and 8.1 ± 0.3 times per day in the spring and autumn, respectively, while grazing the semi-improved pasture. Urination frequency was greater (19.0 ± 0.4 and 15.3 ± 0.3 times per day in the spring and autumn, respectively) in the unimproved pasture. Ewe squat duration could be reliably used to predict the volume of urine deposited per event and was thus used to estimate mean daily urine production volumes. Sheep urinated at a rate of 16.6 mL/s and, across the entire dataset, sheep squatted for an average of 9.62 ± 0.03 s per squatting event, producing an estimated average individual urine event volume of 159 ± 1 mL (n = 35 946 events), ranging between 17 and 745 mL (for squat durations of 1 to 45 s). The estimated mean daily urine volume was 2.15 ± 0.04 L (n = 2 669 days) across the entire dataset. The data will be useful for modelling studies estimating N losses (e.g. ammonia (NH3) volatilisation, nitrous oxide (N2O) emission via nitrification and denitrification and nitrate (NO3−) leaching) from urine patches

    Riparian buffer strips influence nitrogen losses as nitrous oxide and leached N from upslope permanent pasture

    Get PDF
    Riparian buffer strips can have a significant role in reducing nitrogen (N) transfers from agricultural land to freshwater primarily via denitrification and plant uptake processes, but an unintended trade-off can be elevated nitrous oxide (N2O) production rates. Against this context, our replicated bounded plot scale study investigated N2O emissions from un-grazed ryegrass pasture served by three types of riparian buffer strips with different vegetation, comprising: (i) grass riparian buffer with novel deep-rooting species, (ii) willow (young trees at establishment phase) riparian buffer, and (iii) deciduous woodland (also young trees at establishment phase) riparian buffer. The experimental control was ryegrass pasture with no buffer strip. N2O emissions were measured at the same time as total oxidized N in run-off, and soil and environmental characteristics in the ri parian buffer strips and upslope pasture between 2018 and 2019. During most of the sampling days, the no-buffer control treatment showed significantly (P < 0.05) greater N2O fluxes and cumulative N2O emissions compared to the remainder of the treatments. Our results also showed that the grass riparian buffer strip is a sink of N2O equivalent to − 2310.2 g N2O-N ha− 1 day− 1 (95% confidence interval:− 535.5 to 492). Event-based water quality results obtained during storms (12 November 2018 and 11 February 2019) showed that the willow riparian buffer treatment had the highest flow-weighted mean N concentrations (N-FWMC) of 0.041 ± 0.022 and 0.031 ± 0.015 mg N L− 1, when compared to the other treatments. Our 9-month experiment therefore, shows that ri parian buffer strips with novel deep-rooting grass can therefore potentially address emissions to both water and air. The results imply that over a shorter timeline similar to the current study, the grass riparian buffer strip can potentially address N emission to both air and water, particularly when serving a permanent pasture in similar settings as the current experiment.Fil: Dlamini, J.C. Crop and Climate Sciences. Departament of Soil; Sudáfrica. Rothamsted Research. Sustainable Agriculture Sciences; Reino Unido. University of Pretoria. Department of Plant and Soil Sciences; SudáfricaFil: Cardenas, L.M. Rothamsted Research. Sustainable Agriculture Sciences; Reino Unido.Fil: Tesfamarian, E.H. University of Pretoria. Department of Plant and Soil Sciences; SudáfricaFil: Dunn, R.M. Rothamsted Research. Sustainable Agriculture Sciences; Reino Unido.Fil: Loick, N. Rothamsted Research. Sustainable Agriculture Sciences; Reino Unido.Fil: Charteris, A.F. Rothamsted Research. Sustainable Agriculture Sciences; Reino Unido.Fil: Cocciaglia, L. Università degli Studi di Perugia. Dipartimento di Scienze Agrarie, Alimentari e Ambientali; ItaliaFil: Vangeli, Sebastián. Instituto Nacional de Tecnología Agropecuaria (INTA). Instituto de Clima y Agua; Argentina. Consejo Nacional de Investigaciones Científicas y Técnicas; Argentina. Universidad de Buenos Aires. Facultad de Agronomía. Departamento de Ingeniería Agrícola y Uso de la Tierra. Cátedra de Manejo y Conservación de Suelo; ArgentinaFil: Blackwell, M.S.A. Rothamsted Research. Sustainable Agriculture Sciences; Reino Unido.Fil: Upadhayay, H.R. Rothamsted Research. Sustainable Agriculture Sciences; Reino Unido.Fil: Hawkins, J.M.B. Rothamsted Research. Sustainable Agriculture Sciences; Reino Unido.Fil: Evans, J. Rothamsted Research. Computational and Analytical Sciences; Reino UnidoFil: Collins, A.L. Rothamsted Research. Sustainable Agriculture Sciences; Reino Unido

    A Model for the Development of the Rhizobial and Arbuscular Mycorrhizal Symbioses in Legumes and Its Use to Understand the Roles of Ethylene in the Establishment of these two Symbioses

    Get PDF
    We propose a model depicting the development of nodulation and arbuscular mycorrhizae. Both processes are dissected into many steps, using Pisum sativum L. nodulation mutants as a guideline. For nodulation, we distinguish two main developmental programs, one epidermal and one cortical. Whereas Nod factors alone affect the cortical program, bacteria are required to trigger the epidermal events. We propose that the two programs of the rhizobial symbiosis evolved separately and that, over time, they came to function together. The distinction between these two programs does not exist for arbuscular mycorrhizae development despite events occurring in both root tissues. Mutations that affect both symbioses are restricted to the epidermal program. We propose here sites of action and potential roles for ethylene during the formation of the two symbioses with a specific hypothesis for nodule organogenesis. Assuming the epidermis does not make ethylene, the microsymbionts probably first encounter a regulatory level of ethylene at the epidermis–outermost cortical cell layer interface. Depending on the hormone concentrations there, infection will either progress or be blocked. In the former case, ethylene affects the cortex cytoskeleton, allowing reorganization that facilitates infection; in the latter case, ethylene acts on several enzymes that interfere with infection thread growth, causing it to abort. Throughout this review, the difficulty of generalizing the roles of ethylene is emphasized and numerous examples are given to demonstrate the diversity that exists in plants

    Depth Of Maximum Of Air-shower Profiles At The Pierre Auger Observatory. I. Measurements At Energies Above 1017.8ev

    Get PDF
    901

    Commissioning and performance of the CMS pixel tracker with cosmic ray muons

    Get PDF
    This is the Pre-print version of the Article. The official published verion of the Paper can be accessed from the link below - Copyright @ 2010 IOPThe pixel detector of the Compact Muon Solenoid experiment consists of three barrel layers and two disks for each endcap. The detector was installed in summer 2008, commissioned with charge injections, and operated in the 3.8 T magnetic field during cosmic ray data taking. This paper reports on the first running experience and presents results on the pixel tracker performance, which are found to be in line with the design specifications of this detector. The transverse impact parameter resolution measured in a sample of high momentum muons is 18 microns.This work is supported by FMSR (Austria); FNRS and FWO (Belgium); CNPq, CAPES, FAPERJ, and FAPESP (Brazil); MES (Bulgaria); CERN; CAS, MoST, and NSFC (China); COLCIENCIAS (Colombia); MSES (Croatia); RPF (Cyprus); Academy of Sciences and NICPB (Estonia); Academy of Finland, ME, and HIP (Finland); CEA and CNRS/IN2P3 (France); BMBF, DFG, and HGF (Germany); GSRT (Greece); OTKA and NKTH (Hungary); DAE and DST (India); IPM (Iran); SFI (Ireland); INFN (Italy); NRF (Korea); LAS (Lithuania); CINVESTAV, CONACYT, SEP, and UASLP-FAI (Mexico); PAEC (Pakistan); SCSR (Poland); FCT (Portugal); JINR (Armenia, Belarus, Georgia, Ukraine, Uzbekistan); MST and MAE (Russia); MSTDS (Serbia); MICINN and CPAN (Spain); Swiss Funding Agencies (Switzerland); NSC (Taipei); TUBITAK and TAEK (Turkey); STFC (United Kingdom); DOE and NSF (USA)

    Alignment of the CMS silicon tracker during commissioning with cosmic rays

    Get PDF
    This is the Pre-print version of the Article. The official published version of the Paper can be accessed from the link below - Copyright @ 2010 IOPThe CMS silicon tracker, consisting of 1440 silicon pixel and 15 148 silicon strip detector modules, has been aligned using more than three million cosmic ray charged particles, with additional information from optical surveys. The positions of the modules were determined with respect to cosmic ray trajectories to an average precision of 3–4 microns RMS in the barrel and 3–14 microns RMS in the endcap in the most sensitive coordinate. The results have been validated by several studies, including laser beam cross-checks, track fit self-consistency, track residuals in overlapping module regions, and track parameter resolution, and are compared with predictions obtained from simulation. Correlated systematic effects have been investigated. The track parameter resolutions obtained with this alignment are close to the design performance.This work is supported by FMSR (Austria); FNRS and FWO (Belgium); CNPq, CAPES, FAPERJ, and FAPESP (Brazil); MES (Bulgaria); CERN; CAS, MoST, and NSFC (China); COLCIENCIAS (Colombia); MSES (Croatia); RPF (Cyprus); Academy of Sciences and NICPB (Estonia); Academy of Finland, ME, and HIP (Finland); CEA and CNRS/IN2P3 (France); BMBF, DFG, and HGF (Germany); GSRT (Greece); OTKA and NKTH (Hungary); DAE and DST (India); IPM (Iran); SFI (Ireland); INFN (Italy); NRF (Korea); LAS (Lithuania); CINVESTAV, CONACYT, SEP, and UASLP-FAI (Mexico); PAEC (Pakistan); SCSR (Poland); FCT (Portugal); JINR (Armenia, Belarus, Georgia, Ukraine, Uzbekistan); MST and MAE (Russia); MSTDS (Serbia); MICINN and CPAN (Spain); Swiss Funding Agencies (Switzerland); NSC (Taipei); TUBITAK and TAEK (Turkey); STFC (United Kingdom); DOE and NSF (USA)

    Performance of the CMS drift-tube chamber local trigger with cosmic rays

    Get PDF
    The performance of the Local Trigger based on the drift-tube system of the CMS experiment has been studied using muons from cosmic ray events collected during the commissioning of the detector in 2008. The properties of the system are extensively tested and compared with the simulation. The effect of the random arrival time of the cosmic rays on the trigger performance is reported, and the results are compared with the design expectations for proton-proton collisions and with previous measurements obtained with muon beams

    Performance of the CMS Level-1 trigger during commissioning with cosmic ray muons and LHC beams

    Get PDF
    This is the Pre-print version of the Article. The official published version can be accessed from the link below - Copyright @ 2010 IOPThe CMS Level-1 trigger was used to select cosmic ray muons and LHC beam events during data-taking runs in 2008, and to estimate the level of detector noise. This paper describes the trigger components used, the algorithms that were executed, and the trigger synchronisation. Using data from extended cosmic ray runs, the muon, electron/photon, and jet triggers have been validated, and their performance evaluated. Efficiencies were found to be high, resolutions were found to be good, and rates as expected.This work is supported by FMSR (Austria); FNRS and FWO (Belgium); CNPq, CAPES, FAPERJ, and FAPESP (Brazil); MES (Bulgaria); CERN; CAS, MoST, and NSFC (China); COLCIENCIAS (Colombia); MSES (Croatia); RPF (Cyprus); Academy of Sciences and NICPB (Estonia); Academy of Finland, ME, and HIP (Finland); CEA and CNRS/IN2P3 (France); BMBF, DFG, and HGF (Germany); GSRT (Greece); OTKA and NKTH (Hungary); DAE and DST (India); IPM (Iran); SFI (Ireland); INFN (Italy); NRF (Korea); LAS (Lithuania); CINVESTAV, CONACYT, SEP, and UASLP-FAI (Mexico); PAEC (Pakistan); SCSR (Poland); FCT (Portugal); JINR (Armenia, Belarus, Georgia, Ukraine, Uzbekistan); MST and MAE (Russia); MSTDS (Serbia); MICINN and CPAN (Spain); Swiss Funding Agencies (Switzerland); NSC (Taipei); TUBITAK and TAEK (Turkey); STFC (United Kingdom); DOE and NSF (USA)

    Performance of the CMS hadron calorimeter with cosmic ray muons and LHC beam data

    Get PDF
    This is the Pre-print version of the Article. The official published version of the Paper can be accessed from the link below - Copyright @ 2010 IOPThe CMS Hadron Calorimeter in the barrel, endcap and forward regions is fully commissioned. Cosmic ray data were taken with and without magnetic field at the surface hall and after installation in the experimental hall, hundred meters underground. Various measurements were also performed during the few days of beam in the LHC in September 2008. Calibration parameters were extracted, and the energy response of the HCAL determined from test beam data has been checked.This work is supported by FMSR (Austria); FNRS and FWO (Belgium); CNPq, CAPES, FAPERJ, and FAPESP (Brazil); MES (Bulgaria); CERN; CAS, MoST, and NSFC (China); COLCIENCIAS (Colombia); MSES (Croatia); RPF (Cyprus); Academy of Sciences and NICPB (Estonia); Academy of Finland, ME, and HIP (Finland); CEA and CNRS/IN2P3 (France); BMBF, DFG, and HGF (Germany); GSRT (Greece); OTKA and NKTH (Hungary); DAE and DST (India); IPM (Iran); SFI (Ireland); INFN (Italy); NRF (Korea); LAS (Lithuania); CINVESTAV, CONACYT, SEP, and UASLP-FAI (Mexico); PAEC (Pakistan); SCSR (Poland); FCT (Portugal); JINR (Armenia, Belarus, Georgia, Ukraine, Uzbekistan); MST and MAE (Russia); MSTDS (Serbia); MICINN and CPAN (Spain); Swiss Funding Agencies (Switzerland); NSC (Taipei); TUBITAK and TAEK (Turkey); STFC (United Kingdom); DOE and NSF (USA)
    corecore